USE [ERP]
GO

/****** Object:  StoredProcedure [dbo].[SP_PUBLIC_HOLIDAY_GET]    Script Date: 11/16/2009 14:39:02 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[SP_PUBLIC_HOLIDAY_GET]	
	@startDate date	,
	@endDate date	
AS
BEGIN	
	SELECT Date, Name, MultiplyFactor FROM PublicHoliday 
		WHERE Date BETWEEN @startDate AND @endDate ;
END

GO

